package avicit.bdp.dcs.utils;

/**
 * @金航数码科技有限责任公司
 * @作者：liyb
 * @邮箱：developer@avic-digital.com
 * @创建时间： 2020-08-29 11:55
 * @类说明：DataTypeConstants
 * @修改记录：
 */
public interface DataTypeConstants {

    // Mysql
    public static final String VARCHAR = "varchar";
    public static final String CHAR = "char";
    public static final String TINYINT = "tinyint";
    public static final String SMALLINT = "smallint";
    public static final String MEDIUMINT = "mediumint";
    public static final String INT = "int";
    public static final String BIGINT = "bigint";
    public static final String FLOAT = "float";
    public static final String DOUBLE = "double";
    public static final String DECIMAL = "decimal";
    public static final String DATETIME = "datetime";
    public static final String TIMESTAMP = "timestamp";
    public static final String DATE = "date";
    public static final String TIME = "time";
    public static final String TEXT = "text";
    public static final String MEDIUMTEXT = "mediumtext";
    public static final String TINYTEXT = "tinytext";
    public static final String LONGTEXT = "longtext";
    public static final String BLOB = "blob";
    public static final String MEDIUMBLOB = "mediumblob";
    public static final String TINYBLOB = "tinyblob";
    public static final String LONGBLOB = "longblob";
    public static final String VARBINARY = "varbinary";

    // Oracle
    public static final String VARCHAR2 = "varchar2";
    public static final String NVARCHAR2 = "nvarchar2";
    public static final String NUMBER = "number";
    public static final String LONG = "long";
    public static final String CLOB = "clob";
    public static final String NCLOB = "nclob";
    public static final String LONG_RAW = "long raw";
    public static final String RAW = "raw";

    // SqlServer
    public static final String NVARCHAR = "nvarchar";
    public static final String NCHAR = "nchar";
    public static final String NTEXT = "ntext";

    // Postgresql
    public static final String CHARACTER_VARYING = "character varying";
    public static final String CHARACTER = "character";
    public static final String INTEGER = "integer";
    public static final String DOUBLE_PRECISION = "double precision";
    public static final String NUMERIC = "numeric";
    public static final String REAL = "real";
    public static final String SMALL_SERIAL = "smallserial";
    public static final String SERIAL = "serial";
    public static final String BIG_SERIAL = "bigserial";

    // 其他
    public static final String STRING = "string";
    public static final String BOOLEAN = "boolean";

    // 达梦
    public static final String DEC = "dec";
    public static final String BYTE = "byte";
    public static final String TIME_WITH_TIME_ZONE = "time_with_time_zone";
    public static final String TIMESTAMP_WITH_TIME_ZONE = "timestamp_with_time_zone";
    public static final String TIMESTAMP_WITH_LOCAL_TIME_ZONE = "timestamp_with_local_time_zone";
    public static final String DATETIME_WITH_TIME_ZONE = "datetime_with_time_zone";

}
